Ì € i 2
sch.clin.date.comments.by.cons (date.comments.cons)
[cons.doctor, cons.date]
&SCDC[ggg]DC[cdc]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cons.date 10 DATE L cdc
cons.date.comment 50 FREE L &SCDC[ggg]DC[cdc]|0
Ì i 2
sch.clin.locals (locals)
Field Name Len Dat Typ J DPM Offset/Local/VAL
appt.date 8 DATE L
appt.time 4 ZCUS.MIN L
can.close.flag 3 FREE L
date.available 10 DATE L
dummy.section 0 FREE L
num.booked 1 PINT R
pointer.date 8 DATE L
schedule.date 8 DATE L
schedule.end.date 8 DATE L
yn 1 YN L
Ì i 2
sch.clinic.dictionary (main)
[mnemonic]
&SC[scc]
Field Name Len Dat Typ J DPM Offset/Local/VAL
mnemonic 10 FREE L scc
active 1 YN L &SC[scc]|0
adm.facility 10 FREE L MIS.FACILITY &SC[scc]|11
appt.ltr 10 FREE L SCH.LET &SC[scc]|7
ask.model.box.number 1 YN L &SC[scc]|14
book.in.ltr 10 FREE L SCH.LET &SC[scc]|20
cancel.ltr.dna 10 FREE L SCH.LET &SC[scc]|18
cancel.ltr.hospital 10 FREE L SCH.LET &SC[scc]|16
cancel.ltr.other 10 FREE L SCH.LET &SC[scc]|19
cancel.ltr.patient 10 FREE L SCH.LET &SC[scc]|17
chg.ltr 10 FREE L SCH.LET &SC[scc]|9
clinic.id 45 FREE L VAL=@mnemonic_" - "_@name
clinic.list 2 PINT R &SC[scc]L|0
date.comments.defined 1 FREE L VAL=IF{+&SC[mnemonic]DC[""] 1;""}
default.appt.type 10 FREE L SCH.APP.TYP &SC[scc]|13
do.not.use.8 10 FREE L &SC[scc]|8
doctor 10 FREE L MIS.DOC.DICT &SC[scc]|2
doctor.id 45 FREE L VAL=@doctor_" - "_@MIS.DOC.DICT.name[@doctor]
follow.up.clinic.default 10 FREE L SCH.CLIN.DICT &SC[scc]|12
last.update 10 PINT R &SC[scc]UPD
location 10 FREE L MIS.LOCN.DICT &SC[scc]|4
name 30 FREE L &SC[scc]|1
overbook.allowed 1 YN L &SC[scc]|10
preoperative.clinic 1 YN L &SC[scc]|21
rev.ltr 10 FREE L SCH.LET &SC[scc]|6
slots.appts 2 PINT R &SC[scc]L|1
spec.service 10 FREE L MIS.SVC.DICT &SC[scc]|5
stats.spec.group 10 FREE L SCH.CLIN.STATS &SC[scc]|15
web.enabled 1 YN L &SC[scc]WEB|0
Ì € i 2
sch.clin.avail.holidays (avail.holidays)
[mnemonic, avail.holiday]
&SC[scc]H[hldy]
Field Name Len Dat Typ J DPM Offset/Local/VAL
avail.holiday 10 FREE L MIS.HOLIDAY hldy
Ì € i 2
sch.clin.compatible.clinics (compatible.clinics)
[mnemonic, compatible.clinic]
&SC[scc]CC[cscc]
Field Name Len Dat Typ J DPM Offset/Local/VAL
compatible.clinic 10 FREE L SCH.CLIN.DICT cscc
Ì € i 2
sch.clin.consultants (consultants)
[mnemonic, consultant]
&SC[scc]CON[ggg]
Field Name Len Dat Typ J DPM Offset/Local/VAL
consultant 10 FREE L MIS.DOC.DICT ggg
consultant.field 1 FREE L &SC[scc]CON[ggg]|1
consultant.service 10 FREE L MIS.SVC.DICT &SC[scc]CON[ggg]|0
Ì € i 2
sch.clin.date.comments (date.comments)
[mnemonic, date]
&SC[scc]DC[cdc]
Field Name Len Dat Typ J DPM Offset/Local/VAL
date 10 DATE L cdc
date.comment 50 FREE L &SC[scc]DC[cdc]|0
date.comment.from 1 YN L &SC[scc]DC[cdc]|1
Ì € i 2
sch.clin.facilities (facilities)
[mnemonic, facility]
&SC[scc]FAC[gqb]
Field Name Len Dat Typ J DPM Offset/Local/VAL
facility 10 FREE L MIS.FACILITY gqb
Ì € i 2
sch.clin.periods (periods)
[mnemonic, period.start.date]
&SC[scc]P[scps]
Field Name Len Dat Typ J DPM Offset/Local/VAL
period.start.date 8 DATE L scps
period.active 1 YN L &SC[scc]P[scps]|0
period.end.date 8 DATE L &SC[scc]P[scps]|1
Ì € i 2
sch.clin.days (days)
[mnemonic,period.start.date, day]
&SC[scc]P[scps]D[scd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
day 3 DAY L scd
day.active 1 YN L &SC[scc]P[scps]D[scd]|0
day.cycle 2 PINT R &SC[scc]P[scps]D[scd]|2
day.frequency.description 30 FREE L &SC[scc]P[scps]D[scd]|3
day.type 7 CHOICE L &SC[scc]P[scps]D[scd]|1
Ì € i 2
sch.clin.monthly.patterns (day.monthly.patterns)
[mnemonic,period.start.date,day, month]
&SC[scc]P[scps]D[scd]M[mth]
Field Name Len Dat Typ J DPM Offset/Local/VAL
month 3 PINT R mth
Ì € i 2
sch.clin.monthly.weeks (day.monthly.weeks)
[mnemonic,period.start.date,day,month, monthly.week]
&SC[scc]P[scps]D[scd]M[mth]W[mweek]
Field Name Len Dat Typ J DPM Offset/Local/VAL
monthly.week 1 CHOICE L mweek
Ì € i 2
sch.clin.day.patterns (day.weekly.patterns)
[mnemonic,period.start.date,day, week]
&SC[scc]P[scps]D[scd]W[wk]
Field Name Len Dat Typ J DPM Offset/Local/VAL
week 3 PINT R wk
Ì € i 2
sch.clin.sessions (sessions)
[mnemonic,period.start.date,day, session.start.time]
&SC[scc]P[scps]D[scd]S[scpss]
Field Name Len Dat Typ J DPM Offset/Local/VAL
session.start.time 4 ZCUS.MIN L scpss
session.active 1 YN L &SC[scc]P[scps]D[scd]S[scpss]|0
session.appt.all.same.len 1 YN L &SC[scc]P[scps]D[scd]S[scpss]|8
session.def.appt.avail 1 YN L &SC[scc]P[scps]D[scd]S[scpss]|7
session.def.appt.bk 2 FREE L &SC[scc]P[scps]D[scd]S[scpss]|5
session.def.appt.len 4 PINT R &SC[scc]P[scps]D[scd]S[scpss]|3
session.def.appt.pri 1 CHOICE L &SC[scc]P[scps]D[scd]S[scpss]|4
session.def.appt.vis.type 1 CHOICE L &SC[scc]P[scps]D[scd]S[scpss]|6
session.end.time 4 ZCUS.MIN L &SC[scc]P[scps]D[scd]S[scpss]|1
session.end.time.ext 4 FREE L VAL=%Z.zcus.uk.min.to.hhmm(@session.end.time)
session.held.by 10 FREE L MIS.DOC.TYPE &SC[scc]P[scps]D[scd]S[scpss]|2
session.held.by.cons 1 YN L &SC[scc]P[scps]D[scd]S[scpss]|9
session.start.time.ext 4 FREE L VAL=%Z.zcus.uk.min.to.hhmm(@session.start.time)
Ì € i 2
sch.clin.session.appts (session.appts)
[mnemonic,period.start.date,day,session.start.time, session.appt.start]
&SC[scc]P[scps]D[scd]S[scpss]A[sccsa]
Field Name Len Dat Typ J DPM Offset/Local/VAL
session.appt.start 4 ZCUS.MIN L sccsa
session.appt.available 1 YN L &SC[scc]P[scps]D[scd]S[scpss]A[sccsa]|5
session.appt.book.factor 2 FREE L &SC[scc]P[scps]D[scd]S[scpss]A[sccsa]|4
session.appt.end 4 ZCUS.MIN L &SC[scc]P[scps]D[scd]S[scpss]A[sccsa]|0
session.appt.length 4 PINT R &SC[scc]P[scps]D[scd]S[scpss]A[sccsa]|1
session.appt.priority 1 CHOICE L &SC[scc]P[scps]D[scd]S[scpss]A[sccsa]|2
session.appt.type 1 CHOICE L &SC[scc]P[scps]D[scd]S[scpss]A[sccsa]|3
Ì € i 2
sch.clin.sessions.appts.queue (session.appts.queue)
[mnemonic,period.start.date,day,session.start.time, appt.queue]
&SC[scc]P[scps]D[scd]S[scpss]A[tempq]
Field Name Len Dat Typ J DPM Offset/Local/VAL
appt.queue 3 FREE L tempq
avail.q 1 YN L &SC[scc]P[scps]D[scd]S[scpss]A[tempq]|6
bk.q 2 FREE L &SC[scc]P[scps]D[scd]S[scpss]A[tempq]|5
cancel.q 1 YN L &SC[scc]P[scps]D[scd]S[scpss]A[tempq]|7
end.q 4 ZCUS.MIN L &SC[scc]P[scps]D[scd]S[scpss]A[tempq]|1
len.q 4 PINT R &SC[scc]P[scps]D[scd]S[scpss]A[tempq]|2
pri.q 1 CHOICE L &SC[scc]P[scps]D[scd]S[scpss]A[tempq]|3
start.q 4 ZCUS.MIN L &SC[scc]P[scps]D[scd]S[scpss]A[tempq]|0
type.q 1 CHOICE L &SC[scc]P[scps]D[scd]S[scpss]A[tempq]|4
Ì € i 2
sch.clin.priorities (priorities)
[mnemonic, priority]
&SC[scc]PRI[ggc]
Field Name Len Dat Typ J DPM Offset/Local/VAL
priority 10 FREE L MIS.ADM.PRIORT ggc
maps.to 1 CHOICE L &SC[scc]PRI[ggc]|0
Ì € i 2
sch.clin.tolernaces (tolerances)
[mnemonic, tol.week]
&SC[scc]TOL[sctw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
tol.week 3 PINT R sctw
tol.minus 3 INT R &SC[scc]TOL[sctw]|2
tol.plus 3 INT R &SC[scc]TOL[sctw]|1
tol.week.end 3 PINT R &SC[scc]TOL[sctw]|0
Ì € i 2
sch.clin.tolerances.q (tolerances.q)
[mnemonic, tol.q]
&SC[scc]TOL[tolq]
Field Name Len Dat Typ J DPM Offset/Local/VAL
tol.q 3 PINT R tolq
tol.minus.q 3 INT R &SC[scc]TOL[tolq]|3
tol.plus.q 3 INT R &SC[scc]TOL[tolq]|2
tol.week.end.q 3 PINT R &SC[scc]TOL[tolq]|1
tol.week.q 3 PINT R &SC[scc]TOL[tolq]|0
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
sch.clin.can.sess.conflicts.x [mnemonic,date,session.start.time]
can.conflict.x &SCCANX[scc,cdc,scpss]
sch.clin.clsd.sess.conflicts.x [mnemonic,date,session.start.time]
close.conflict.x &SCCLX[scc,cdc,scpss]
sch.clin.dates.available.x [mnemonic,date.available] = period.start.date
dates.available &SCDA[scc,xdate]
sch.clin.dates.avail.cal.x [mnemonic,date.available] = 0
dates.available.cal &SCDAC[scc,xdate]
sch.clin.dates.by.session.x [mnemonic,date.available,session.start.time] = session.end.time
dates.by.session &SCDAS[scc,xdate,scpss]
sch.clin.doc.index [doctor,mnemonic]
doctor.x &SCDX[ggg,scc]
sch.clin.point.to.schedules.x [mnemonic,schedule.date] = period.start.date
pointer.to.schedules &SCSPX[scc,sd]
sch.clin.schedule.index [mnemonic,schedule.date] = schedule.end.date
schedule.index &SCSSX[scc,sd]
sch.clin.service.index [spec.service,mnemonic]
service.x &SCSX[ggs,scc]
web.enabled.consultant.index [doctor,mnemonic]
web.doctor.x &SCDXWEB[ggg,scc]
web.enabled.service.index [spec.service,mnemonic]
web.service.x &SCSXWEB[ggs,scc]
|
|
| | | | | | | | | | | | | | | | | |